www.gusucode.com > Python spider抓取内容并分词源码程序 > Python spider抓取内容并分词/Pythonspidermaster/Pythonspider-master/bilibili/bilidata.php

    <?php 

$link = mysqli_connect('localhost:3306', 'root', '');
mysqli_select_db($link,'test');
mysqli_set_charset($link,'utf8');
$limit = $_GET['limit'] ? $_GET['limit'] : 15;//up数量
$by = $order = $_GET['order'] ? $_GET['order'] : 'play';//排序字段
$average = $_GET['average'];
$fields = array("play"=>"播放量","coin"=>"硬币数","collect"=>"收藏数","danmu"=>"弹幕数");
if(!isset($fields[$order])){
	echo 0;
	die;
}
if($average){
	$by = 'avg'.$order;
}
$sql = "SELECT author_name,count('*') as 'avNum', AVG(`{$order}`) as avg{$order},sum(`{$order}`) as {$order} FROM `bilibili` group by author order by {$order} DESC limit {$limit}";


$result = mysqli_query($link,$sql);
file_put_contents("a.txt", $sql);

$data['name'] = $average ? "平均每视频".$fields[$order] :$fields[$order];
while($row = mysqli_fetch_array($result))
{
	if($average){
		$num = intval($row['avg'.$order]);
	}else{
		$num = intval($row[$order]);
	}
	$sort[] = $num;
	$tmp = array($row['author_name'],$num);
	$data['data'][] = $tmp;
}

array_multisort($data['data'],SORT_ASC ,SORT_NUMERIC ,$sort);
$callback = $_GET['callback'] ? $_GET['callback'] :"callback";

echo "{$callback}(".json_encode($data).")";